/*
MySQL Backup
Source Server Version: 5.7.18
Source Database: cloud_user1
Date: 2018/4/25 10:47:35
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
--  Table structure for `app_user`
-- ----------------------------
DROP TABLE IF EXISTS `app_user`;
CREATE TABLE `app_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` varchar(60) NOT NULL,
  `nickname` varchar(255) DEFAULT NULL,
  `headImgUrl` varchar(1024) DEFAULT NULL,
  `phone` varchar(11) DEFAULT NULL,
  `sex` tinyint(1) DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `type` varchar(16) NOT NULL,
  `createTime` datetime NOT NULL,
  `updateTime` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Table structure for `sys_config`
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `org_id` int(11) DEFAULT NULL COMMENT '组织机构id',
  `type` varchar(64) DEFAULT NULL COMMENT '类型',
  `json` varchar(64) DEFAULT NULL COMMENT '设置json',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统配置表';

-- ----------------------------
--  Table structure for `sys_dict`
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `org_id` int(11) DEFAULT NULL COMMENT '组织机构id',
  `parent_id` int(11) DEFAULT NULL COMMENT '父级id',
  `value` varchar(64) DEFAULT NULL COMMENT '值',
  `lable` varchar(64) DEFAULT NULL COMMENT '标签',
  `type` varchar(64) DEFAULT NULL COMMENT '类型',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `scope` varchar(64) DEFAULT NULL COMMENT '系统级还是用户级',
  `enabled` varchar(11) DEFAULT NULL COMMENT '用户类型',
  `del_flag` int(11) DEFAULT NULL COMMENT '逻辑删除标记',
  `create_time` date DEFAULT NULL COMMENT '创建时间',
  `update_time` date DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='字典表';

-- ----------------------------
--  Table structure for `sys_menu`
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `org_id` int(11) DEFAULT NULL COMMENT '组织机构id',
  `parent_id` int(11) DEFAULT NULL COMMENT '父级id',
  `parent_ids` varchar(256) DEFAULT NULL COMMENT '父级ids',
  `org_ids_show` varchar(2000) DEFAULT NULL COMMENT '包含此菜单的机构ids',
  `org_ids_hide` varchar(2000) DEFAULT NULL COMMENT '不包含此菜单的机构ids',
  `name` varchar(256) DEFAULT NULL COMMENT '菜单名称',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `url` varchar(256) DEFAULT NULL COMMENT '链接',
  `icon` varchar(256) DEFAULT NULL COMMENT '图标',
  `type` int(11) DEFAULT NULL COMMENT '是菜单还是按钮（1：菜单，2：按钮）',
  `permission` varchar(64) DEFAULT NULL COMMENT '权限标识',
  `remarks` varchar(256) DEFAULT NULL COMMENT '备注信息',
  `enabled` varchar(11) DEFAULT NULL,
  `del_flag` varchar(2) DEFAULT NULL COMMENT '逻辑删除标记',
  `create_time` date DEFAULT NULL COMMENT '创建时间',
  `update_time` date DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COMMENT='菜单表';

-- ----------------------------
--  Table structure for `sys_organization`
-- ----------------------------
DROP TABLE IF EXISTS `sys_organization`;
CREATE TABLE `sys_organization` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `org_id` int(11) DEFAULT NULL COMMENT '组织机构id',
  `parent_id` int(11) DEFAULT NULL COMMENT '父级id',
  `headquarters_id` int(11) DEFAULT NULL COMMENT '总校id',
  `area_id` int(11) DEFAULT NULL COMMENT '上级主管单位id',
  `parent_ids` varchar(256) DEFAULT NULL COMMENT '父级ids',
  `parent_names` varchar(2000) DEFAULT NULL COMMENT '父级姓名names',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `type` varchar(64) DEFAULT NULL COMMENT '类型',
  `address` varchar(256) DEFAULT NULL COMMENT '地址',
  `master` varchar(64) DEFAULT NULL COMMENT '联系人（负责人）电话',
  `phone` varchar(64) DEFAULT NULL COMMENT '手机号',
  `web_url` varchar(256) DEFAULT NULL COMMENT '学校网站',
  `partack` varchar(11) DEFAULT NULL COMMENT '是否参与业务',
  `enabled` varchar(11) DEFAULT NULL,
  `del_flag` int(11) DEFAULT NULL COMMENT '逻辑删除标记',
  `create_time` date DEFAULT NULL COMMENT '创建时间',
  `update_time` date DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='组织机构表\r\n';

-- ----------------------------
--  Table structure for `sys_permission`
-- ----------------------------
DROP TABLE IF EXISTS `sys_permission`;
CREATE TABLE `sys_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `permission` varchar(32) NOT NULL,
  `name` varchar(50) NOT NULL,
  `createTime` datetime NOT NULL,
  `updateTime` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permission` (`permission`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Table structure for `sys_role`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(32) NOT NULL COMMENT '角色code',
  `name` varchar(50) NOT NULL COMMENT '角色名',
  `createTime` datetime NOT NULL,
  `updateTime` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Table structure for `sys_role_menu`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `role_id` int(11) DEFAULT NULL COMMENT '职务id',
  `menu_id` int(11) DEFAULT NULL COMMENT '菜单id',
  `org_id` int(11) DEFAULT NULL COMMENT '组织机构id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色菜单表';

-- ----------------------------
--  Table structure for `sys_role_permission`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_permission`;
CREATE TABLE `sys_role_permission` (
  `roleId` int(11) NOT NULL,
  `permissionId` int(11) NOT NULL,
  PRIMARY KEY (`roleId`,`permissionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Table structure for `sys_role_user`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_user`;
CREATE TABLE `sys_role_user` (
  `userId` int(11) NOT NULL,
  `roleId` int(11) NOT NULL,
  PRIMARY KEY (`userId`,`roleId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Table structure for `sys_user`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `org_id` int(11) DEFAULT NULL COMMENT '数据类型',
  `office_id` int(11) DEFAULT NULL COMMENT '部门id',
  `username` varchar(256) DEFAULT NULL COMMENT '用户名',
  `password` varchar(256) DEFAULT NULL COMMENT '密码',
  `nickname` varchar(256) DEFAULT NULL COMMENT '昵称',
  `phone` varchar(64) DEFAULT NULL COMMENT '手机号',
  `sex` varchar(11) DEFAULT NULL COMMENT '性别',
  `type` varchar(64) DEFAULT NULL COMMENT '类型',
  `no` varchar(64) DEFAULT NULL COMMENT '编号',
  `email` varchar(64) DEFAULT NULL COMMENT '邮箱',
  `telphone` varchar(64) DEFAULT NULL COMMENT '电话',
  `head_img_url` varchar(256) DEFAULT NULL COMMENT '头像路径',
  `qrcode` varchar(256) DEFAULT NULL COMMENT '二维码路径',
  `id_card` varchar(64) DEFAULT NULL COMMENT '身份证号',
  `user_type` varchar(11) DEFAULT NULL COMMENT '用户类型',
  `data_scope` varchar(64) DEFAULT NULL COMMENT '数据范围',
  `enabled` varchar(11) DEFAULT NULL,
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  `create_time` date DEFAULT NULL COMMENT '创建时间',
  `update_time` date DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `sys_user_org`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_org`;
CREATE TABLE `sys_user_org` (
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `organization_id` int(11) NOT NULL COMMENT '机构ID',
  `org_id` int(11) NOT NULL COMMENT '组织机构id（分表用）'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `sys_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `role_id` int(11) DEFAULT NULL COMMENT '职务id',
  `org_id` int(11) DEFAULT NULL COMMENT '组织机构id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `user_credentials`
-- ----------------------------
DROP TABLE IF EXISTS `user_credentials`;
CREATE TABLE `user_credentials` (
  `username` varchar(50) NOT NULL COMMENT '用户名或手机号等',
  `type` varchar(16) NOT NULL COMMENT '账号类型（用户名、手机号）',
  `userId` int(11) NOT NULL,
  PRIMARY KEY (`username`),
  KEY `userId` (`userId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户凭证表';

-- ----------------------------
--  Records 
-- ----------------------------
INSERT INTO `app_user` VALUES ('1','admin','$2a$10$3uOoX1ps14CxuotogUoDreW8zXJOZB9XeGdrC/xDV36hhaE8Rn9HO','测试1','','','1','1','APP','2018-01-17 16:56:59','2018-01-17 16:57:01'), ('2','superadmin','$2a$10$.gLkG0j2kM0stWoOvPBvqu0H9uSD0HUlpErI.PTKyZQkSUZIV2wFq','超级管理员',NULL,NULL,'1','1','BACKEND','2018-01-19 20:30:09','2018-01-19 20:30:11');
INSERT INTO `sys_menu` VALUES ('1',NULL,NULL,NULL,NULL,NULL,'保存权限标识',NULL,NULL,NULL,NULL,'back:permission:save',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('2',NULL,NULL,NULL,NULL,NULL,'修改权限标识',NULL,NULL,NULL,NULL,'back:permission:update',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('3',NULL,NULL,NULL,NULL,NULL,'删除权限标识',NULL,NULL,NULL,NULL,'back:permission:delete',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('4',NULL,NULL,NULL,NULL,NULL,'查询权限标识',NULL,NULL,NULL,NULL,'back:permission:query',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('5',NULL,NULL,NULL,NULL,NULL,'添加角色',NULL,NULL,NULL,NULL,'back:role:save',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('6',NULL,NULL,NULL,NULL,NULL,'修改角色',NULL,NULL,NULL,NULL,'back:role:update',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('7',NULL,NULL,NULL,NULL,NULL,'删除角色',NULL,NULL,NULL,NULL,'back:role:delete',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('8',NULL,NULL,NULL,NULL,NULL,'给角色分配权限',NULL,NULL,NULL,NULL,'back:role:permission:set',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('9',NULL,NULL,NULL,NULL,NULL,'用户查询',NULL,NULL,NULL,NULL,'back:user:query',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('10',NULL,NULL,NULL,NULL,NULL,'修改用户',NULL,NULL,NULL,NULL,'back:user:update',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('11',NULL,NULL,NULL,NULL,NULL,'给用户分配角色',NULL,NULL,NULL,NULL,'back:user:role:set',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('12',NULL,NULL,NULL,NULL,NULL,'用户重置密码',NULL,NULL,NULL,NULL,'back:user:password',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('13',NULL,NULL,NULL,NULL,NULL,'添加菜单',NULL,NULL,NULL,NULL,'back:menu:save',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('14',NULL,NULL,NULL,NULL,NULL,'修改菜单',NULL,NULL,NULL,NULL,'back:menu:update',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('15',NULL,NULL,NULL,NULL,NULL,'删除菜单',NULL,NULL,NULL,NULL,'back:menu:delete',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('16',NULL,NULL,NULL,NULL,NULL,'查询菜单',NULL,NULL,NULL,NULL,'back:menu:query',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('17',NULL,NULL,NULL,NULL,NULL,'给角色分配菜单',NULL,NULL,NULL,NULL,'back:menu:set2role',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('18',NULL,NULL,NULL,NULL,NULL,'查询角色',NULL,NULL,NULL,NULL,'back:role:query',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('19',NULL,NULL,NULL,NULL,NULL,'获取用户的角色',NULL,NULL,NULL,NULL,'user:role:byuid',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('20',NULL,NULL,NULL,NULL,NULL,'获取角色的权限',NULL,NULL,NULL,NULL,'role:permission:byroleid',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('21',NULL,NULL,NULL,NULL,NULL,'获取角色的菜单',NULL,NULL,NULL,NULL,'menu:byroleid',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('22',NULL,NULL,NULL,NULL,NULL,'查询黑名单ip',NULL,NULL,NULL,NULL,'ip:black:query',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('23',NULL,NULL,NULL,NULL,NULL,'添加黑名单ip',NULL,NULL,NULL,NULL,'ip:black:save',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('24',NULL,NULL,NULL,NULL,NULL,'删除黑名单ip',NULL,NULL,NULL,NULL,'ip:black:delete',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('25',NULL,NULL,NULL,NULL,NULL,'日志查询',NULL,NULL,NULL,NULL,'log:query',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('26',NULL,NULL,NULL,NULL,NULL,'文件查询',NULL,NULL,NULL,NULL,'file:query',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('27',NULL,NULL,NULL,NULL,NULL,'文件删除',NULL,NULL,NULL,NULL,'file:del',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('28',NULL,NULL,NULL,NULL,NULL,'保存邮件',NULL,NULL,NULL,NULL,'mail:save',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('29',NULL,NULL,NULL,NULL,NULL,'修改邮件',NULL,NULL,NULL,NULL,'mail:update',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('30',NULL,NULL,NULL,NULL,NULL,'邮件查询',NULL,NULL,NULL,NULL,'mail:query',NULL,NULL,NULL,'2018-01-18','2018-01-18'), ('31',NULL,NULL,NULL,NULL,NULL,'短信发送记录查询',NULL,NULL,NULL,NULL,'sms:query',NULL,NULL,NULL,'2018-01-18','2018-01-18');
INSERT INTO `sys_permission` VALUES ('1','back:permission:save','保存权限标识','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('2','back:permission:update','修改权限标识','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('3','back:permission:delete','删除权限标识','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('4','back:permission:query','查询权限标识','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('5','back:role:save','添加角色','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('6','back:role:update','修改角色','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('7','back:role:delete','删除角色','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('8','back:role:permission:set','给角色分配权限','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('9','back:user:query','用户查询','2018-01-18 17:12:00','2018-01-18 17:12:05'), ('10','back:user:update','修改用户','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('11','back:user:role:set','给用户分配角色','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('12','back:user:password','用户重置密码','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('13','back:menu:save','添加菜单','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('14','back:menu:update','修改菜单','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('15','back:menu:delete','删除菜单','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('16','back:menu:query','查询菜单','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('17','back:menu:set2role','给角色分配菜单','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('18','back:role:query','查询角色','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('19','user:role:byuid','获取用户的角色','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('20','role:permission:byroleid','获取角色的权限','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('21','menu:byroleid','获取角色的菜单','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('22','ip:black:query','查询黑名单ip','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('23','ip:black:save','添加黑名单ip','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('24','ip:black:delete','删除黑名单ip','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('25','log:query','日志查询','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('26','file:query','文件查询','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('27','file:del','文件删除','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('28','mail:save','保存邮件','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('29','mail:update','修改邮件','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('30','mail:query','邮件查询','2018-01-18 17:06:39','2018-01-18 17:06:42'), ('31','sms:query','短信发送记录查询','2018-01-18 17:06:39','2018-01-18 17:06:42');
INSERT INTO `sys_role` VALUES ('1','SUPER_ADMIN','超级管理员','2018-01-19 20:32:16','2018-01-19 20:32:18');
INSERT INTO `sys_role_menu` VALUES ('1','1',NULL), ('1','2',NULL), ('1','3',NULL), ('1','4',NULL), ('1','5',NULL), ('1','6',NULL), ('1','7',NULL), ('1','8',NULL), ('1','9',NULL), ('1','10',NULL), ('1','11',NULL), ('1','12',NULL), ('1','13',NULL), ('1','14',NULL), ('1','15',NULL), ('1','16',NULL), ('1','17',NULL), ('1','18',NULL), ('1','19',NULL), ('1','20',NULL), ('1','21',NULL), ('1','22',NULL), ('1','23',NULL), ('1','24',NULL), ('1','25',NULL), ('1','26',NULL), ('1','27',NULL), ('1','28',NULL), ('1','29',NULL), ('1','30',NULL), ('1','31',NULL);
INSERT INTO `sys_role_permission` VALUES ('1','1'), ('1','2'), ('1','3'), ('1','4'), ('1','5'), ('1','6'), ('1','7'), ('1','8'), ('1','9'), ('1','10'), ('1','11'), ('1','12'), ('1','13'), ('1','14'), ('1','15'), ('1','16'), ('1','17'), ('1','18'), ('1','19'), ('1','20'), ('1','21'), ('1','22'), ('1','23'), ('1','24'), ('1','25'), ('1','26'), ('1','27'), ('1','28'), ('1','29'), ('1','30'), ('1','31');
INSERT INTO `sys_role_user` VALUES ('1','1'), ('2','1');
INSERT INTO `sys_user` VALUES ('1',NULL,NULL,'admin','$2a$10$3uOoX1ps14CxuotogUoDreW8zXJOZB9XeGdrC/xDV36hhaE8Rn9HO','测试1','','1','APP',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'1',NULL,'2018-01-17','2018-01-17'), ('2',NULL,NULL,'superadmin','$2a$10$.gLkG0j2kM0stWoOvPBvqu0H9uSD0HUlpErI.PTKyZQkSUZIV2wFq','超级管理员',NULL,'1','BACKEND',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,'2018-01-19','2018-01-19');
INSERT INTO `sys_user_role` VALUES ('1','1',NULL), ('2','1',NULL);
INSERT INTO `user_credentials` VALUES ('admin','USERNAME','1'), ('superadmin','USERNAME','2');